from tortoise import BaseDBAsyncClient


async def upgrade(db: BaseDBAsyncClient) -> str:
    return """
        CREATE TABLE IF NOT EXISTS "airportrwy" (
    "id" CHAR(36) NOT NULL PRIMARY KEY,
    "code" VARCHAR(10),
    "name" VARCHAR(50),
    "airport_name" VARCHAR(100),
    "longitude_start" REAL,
    "latitude_start" REAL,
    "longitude_end" REAL,
    "latitude_end" REAL
);
CREATE TABLE IF NOT EXISTS "aerich" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "version" VARCHAR(255) NOT NULL,
    "app" VARCHAR(100) NOT NULL,
    "content" JSON NOT NULL
);"""


async def downgrade(db: BaseDBAsyncClient) -> str:
    return """
        """
